﻿CREATE TABLE [dbo].[ClientContact] (
    [Id_ClientContact] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Client]        INT           NOT NULL,
    [Name]             VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Department]       VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Phone_Comercial]  VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Phone_Residence]  VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Phone_Cell]       VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Phone_Fax]        VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Email]            VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL
);

